<?php
// erotima ipologismou synolikon pelaton

select count(*) as sum_pelaton
from customers

// erotima ipologismou synolikon paraggelion

select count(*) as sum_paraggelion
from orders

// erotima ipologismou synolikon krepon

select count(*) as sum_krepon
from orders_materials

// erotima ipologismou synolikon ylikon

select material_name, count (material_name) as sum_material_name
from materials
groub by material_name
order by material_name asc

// erotima ipologismou synolikon paraggelion ana mera

select order_timedate, count (order_timedate) as sum_order_timedate
from orders
where order_timedate=''
order by order_timedate asc
?>

